SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555480 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555480 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148315,895544,1048768,353970,552400,1034994,238744,928556,565098,166669,965046,366732,271789,899859,835439,640167,1004520,14342,350462,859809,267638,554475,732438,302185,217861,25267,792280,89136,42467,859510,675748,21251,192612,227411,883291,103021,122903,489735,568058,515927,787309,508771,423939,925477,704707,957544,252748,144442,738747,665697,624580,995439,805890,945736,712076,61517,827660,710128,170883,323103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]