SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584908 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584908 [ RunTime:0.004551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593784,587871,280185,886434,738764,734588,816903,193678,596431,14155,278339,331183,4169,893688,851667,293734,1007031,973051,553034,81264,790670,607401,805851,756260,332754,1034604,949715,256914,712546,965329,883156,1000351,782144,533274,469104,649552,826384,124920,536541,694131,1039894,214821,545052,362013,439964,12529,582199,236839,191889,277882,930050,599465,625625,571864,800213,539221,623898,653453,489213,621064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]