SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563207 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563207 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140257,295223,388242,278946,585050,857200,386802,320500,116945,130990,845138,339567,962953,520528,773606,34283,537830,347168,341066,820064,970467,537777,649871,3385,304463,237495,515697,665749,123153,655848,1010726,875191,154307,529395,436079,886093,591152,885354,23066,418470,983364,439235,946160,226376,411058,815911,390011,1044357,315560,65684,75650,224819,130187,646088,1000540,196688,44404,615971,543354,761297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]