SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332214 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332214 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947842,454921,194862,323327,376419,569950,1018565,788947,298791,691483,222447,618847,443034,747121,492515,553141,380781,247342,101072,669937,566611,588670,162496,173285,476932,796484,718049,900850,814768,987802,14457,149264,981231,110516,1027173,500810,411794,654385,176393,417715,304203,999133,671175,117733,926292,490956,76139,534224,855721,264126,127373,894587,902242,413055,892512,723034,134539,606094,972516,728664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]