SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813180 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813180 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001943,917817,800339,69778,291637,397285,921091,156879,756955,360038,255446,247016,81185,268029,436029,607476,95573,526847,55580,644445,825863,856430,107349,209078,328209,1018037,536723,1013790,92507,255344,479867,1004446,201487,363315,211017,398418,602458,444501,192817,749999,621516,125424,198941,934823,907034,875906,26604,780369,403751,436342,250464,516292,402730,1009184,528816,65761,419988,421579,50844,349263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]