SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541408 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541408 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437764,1014421,14481,175318,223277,987840,4756,221800,654371,713,559726,542939,818348,782608,1047697,165949,136407,340926,931813,727630,571068,10580,624013,882206,188,846540,468481,190830,194181,36325,268879,222536,481622,526103,430095,627352,931981,810439,977564,723304,160379,838091,967589,530391,1029198,596184,1018279,711897,774166,407786,684366,355969,469127,548962,216898,990957,491056,642647,821294,744518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]