SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438601 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438601 [ RunTime:0.003356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679239,655930,652488,1014791,108940,392563,448167,596377,758894,220558,384753,994621,113014,217182,115540,551659,57963,296938,273294,848199,614881,1044268,353727,773082,372331,601731,8133,1045677,23466,475983,865486,688186,553551,1043690,450554,826795,121787,802489,654877,116576,734932,200035,741356,234428,713170,805271,565212,968881,721376,769703,7069,88158,1027202,285523,600301,412301,247964,658426,199381,791572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]