SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450523 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450523 [ RunTime:0.002454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344131,389062,892093,928723,77891,715289,1011573,941247,848894,516883,601023,615375,130300,724664,256156,486643,455630,701594,181159,772116,144515,984897,247620,708804,1002671,367284,737605,734248,164837,693620,120300,322000,998063,222383,188168,372942,788856,655333,836923,916429,118415,58401,47828,996883,13393,1047381,417511,67940,162880,737436,267242,400312,986733,250924,868308,194488,315689,579618,763648,590860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]