SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402270 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402270 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011598,373786,618737,908658,869453,902608,548268,1015242,636369,839679,519468,466846,408871,421814,10243,483059,271475,532550,740371,478793,761028,694576,575309,845844,120558,104504,904635,63780,236967,187482,127451,478513,688583,253857,669175,951607,485733,290515,769768,633833,376447,206274,237213,539909,135247,360893,401842,78565,556537,602835,732047,715208,1005561,437265,671090,725013,444095,989067,127549,54805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]