SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001803s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580518 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580518 [ RunTime:0.005171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201957,386807,714117,201937,1018365,566121,690823,323479,928700,897208,925001,254714,674055,184550,787319,571006,869479,385849,997939,693718,944673,812593,799167,978639,548246,762326,598869,609680,516846,681992,657921,864709,976380,203646,991722,813317,998410,911479,14819,222526,195388,76438,539157,596829,367108,258766,999518,105524,125429,89200,604514,590808,101986,346451,925139,864849,995240,797304,236903,1019391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003923s ]