SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020114 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020114 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047115,567436,371483,660401,360221,811025,470910,146975,402793,906854,185137,969330,55763,229842,441022,18254,204053,1046123,346463,971170,638642,124858,156972,60747,169524,98437,158430,834095,90310,766867,690913,482130,506304,202220,399044,937884,429065,29580,255476,431149,456089,376219,157054,29482,602040,401101,323014,116134,139578,273580,320672,531154,432855,421992,579777,113667,647105,142825,480670,487273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]