SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028802 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028802 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423886,74524,184567,636026,751005,547861,309522,806242,711901,953248,66302,344147,160369,571851,1038929,442283,566237,420179,824527,846275,606039,164536,704618,388479,774096,16350,49392,478775,642277,614378,752393,84480,972239,677564,895077,967247,550958,125388,183337,1019010,256561,744263,1042841,245970,143845,390046,807989,507764,99880,324038,878859,633591,884719,107054,103696,44491,817904,18692,149756,1015202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]