SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103595 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103595 [ RunTime:0.002206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123457,429210,921957,478125,892144,288376,2588,197805,855088,268112,526651,855283,789260,243316,9759,906354,723826,994571,968641,928197,451414,657871,811084,451935,225752,324566,940319,681884,138079,1037322,352010,188576,812628,276536,952407,46248,794361,609426,11983,659635,737243,846089,643838,962389,329216,866985,848158,250634,763449,969028,104806,457097,396217,70284,1006554,808844,595102,404788,256397,251606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]