SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558471 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558471 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619507,633975,152634,146069,511906,612883,539981,1040809,423617,675738,869347,443511,980461,57352,56225,746128,911485,674586,110108,210401,179816,232529,160170,293410,401821,1030988,836384,615045,204570,696737,158747,1037566,898357,655111,940491,465694,483699,311681,733240,1045479,177496,773587,905810,402492,541892,404439,503797,269411,970225,248460,330011,149209,1004093,572947,763688,80053,333499,165486,245746,284987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]