SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010575 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010575 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309319,196471,469548,966426,186539,754837,606460,240318,413200,146209,596915,130318,216043,257630,328898,777089,209766,681914,502596,773767,500898,798357,259243,810359,621670,494130,741030,969785,65011,7511,433832,735728,138482,753113,308133,746700,327762,386503,707732,643779,370349,307608,340828,703326,421225,736760,658269,530972,166718,856767,612958,389109,117872,324118,855199,358309,537497,508875,922943,353763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]