SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419494 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419494 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299357,209616,671998,781035,977696,965870,65748,210406,447912,648536,948020,35552,109637,894007,986359,192430,839853,743149,471266,21722,945396,677380,185179,291560,928354,964750,708064,987086,663289,925582,413142,239678,607758,137804,91742,1011445,671355,1012654,221669,465409,22031,27234,515208,663713,861131,1006029,487174,54396,927352,910020,676120,418262,639438,571213,937534,543931,658222,49973,23256,574421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]