SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451761 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451761 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415494,284855,592737,701052,387305,254353,710832,202663,466381,534534,70418,686167,223753,369907,361788,84676,870020,245306,951559,790775,226484,168842,326038,118170,929945,896550,627018,326404,615581,785806,515740,1012905,617701,582569,671879,69531,250486,583237,211651,158229,3353,309478,22909,664534,536197,393192,49372,524191,248836,352901,701596,4576,1023256,432544,57937,946097,997172,48720,243367,811395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]