SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040754 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040754 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92480,298256,300329,373081,214145,548575,924602,76429,1045404,1047303,966191,136487,1000413,684679,561706,233399,863572,137155,492208,603471,674129,540042,656137,969607,698949,785640,545161,707892,245349,502369,555975,337563,593417,190384,723923,625794,770233,755560,424201,171386,698530,590533,587356,452572,418099,302231,166985,675909,956779,804643,63974,787195,218706,618596,963135,53284,989569,604880,1047267,769120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]