SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524846 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524846 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967961,982528,892485,556125,686243,35066,647125,656201,690720,966483,74003,521187,561362,899349,53584,768100,90805,908044,114280,973305,313711,49893,813229,571815,85306,916417,583767,444608,89454,356785,733970,133269,518383,683274,5425,24614,416946,585194,720003,908839,271196,128894,257192,357808,396096,335625,18990,646445,259705,520884,40399,377998,444698,804125,613578,115415,346290,569211,2972,928234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]