SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531656 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531656 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628861,246376,978939,863967,913564,10527,229715,625230,1024607,525980,104215,443358,1018089,501501,208320,587206,284091,1036399,82772,284162,762920,807516,12109,966627,940736,265760,423285,930626,68036,79742,579746,58277,153516,420679,194853,505306,882413,693822,404028,717617,419589,208543,738724,389811,800574,934276,689743,817974,515512,515486,417577,949534,754391,139583,501466,714428,234193,712600,116103,150972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]