SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413963 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413963 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457232,828743,934566,113273,757139,946562,490613,443328,908401,20860,449125,82741,893680,381384,507496,982919,253639,540448,447087,957724,391475,467713,469913,720098,277845,157141,320407,110462,170552,66940,130536,94509,47752,862797,987638,967585,771220,381051,433187,417264,851775,512171,169734,792950,597922,167057,597914,1027504,907337,99194,553709,981978,1041380,481615,827800,61051,188665,601514,837301,17506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]