SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146151 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146151 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331568,404970,497096,105031,767879,52102,978136,534500,709702,168657,235068,612359,139260,486918,1044539,206915,246047,1015503,444368,167583,764309,28905,141361,848804,844557,218039,946169,876691,973377,529690,281407,760620,967497,315770,285769,225151,271613,184735,733727,424538,622386,12438,231085,727160,821175,271503,180083,910678,800791,811924,921720,491887,592116,393793,656683,153655,740730,12417,969994,826616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]