SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413107 LIMIT 1 [ RunTime:0.001329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413107 [ RunTime:0.003300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619579,655285,259453,363425,254391,683223,738997,912886,481018,830316,199991,95337,764728,226283,278544,843496,638543,1030836,810637,931403,400187,952246,1038194,735641,462564,816576,697846,695086,813,63432,249159,316782,38052,720393,1017859,125174,25910,606860,546139,504357,276195,296061,142551,206057,173476,316482,219123,473228,260084,263787,944059,625728,636384,801194,975614,12424,638942,173884,957575,805840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]