SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438489 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438489 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406400,662924,1259,807541,553919,656623,245970,40661,725637,774094,565203,267038,15187,802973,537127,77833,486463,384084,32047,984446,726800,445175,271853,815491,454601,673400,570368,14450,729964,774394,4377,289844,793095,817164,200893,800316,966173,620562,342919,227661,852568,63234,981591,478191,872639,924920,876682,497061,377507,995276,662802,102505,527699,568178,43106,669819,880840,681037,394712,355884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001519s ]