SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 730315 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 730315 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944055,905207,616334,951040,882182,1035429,31808,287507,994200,873905,359006,662037,1032865,280217,878562,640368,1013514,554531,407518,619701,417448,480531,1033304,256075,183302,278672,456184,2095,946057,703436,1037313,998117,756966,408737,954579,304923,274500,853164,551553,38641,580007,43552,969946,917462,137197,828263,229223,199866,950509,788436,438819,303065,950541,167330,223110,928140,457285,23968,160675,531438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 730315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 730315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]