SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 650571 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 650571 [ RunTime:0.004599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468662,487507,64453,325614,673665,15689,679210,708002,426819,992886,376342,551779,91871,38602,71431,520898,95581,1012152,1028822,44767,92868,466031,711821,257813,40607,848794,1008005,695280,680811,766410,864785,248197,816440,510581,569016,399834,740430,868814,831406,801123,1022065,585842,148691,475372,251476,92211,124927,378701,732939,519986,492563,201594,218659,171999,33241,458361,594522,90260,271090,412935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 650571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 650571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]