SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046560 LIMIT 1 [ RunTime:0.006950s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046560 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462641,770106,544992,966791,1019482,997829,612713,584973,417446,681102,470488,873450,403825,934353,611627,839828,94642,461418,878622,695915,843519,783675,34683,463532,601550,104216,319212,50328,435559,626358,1042366,246310,540879,174147,822748,800616,4481,1431,96946,997900,3588,839893,634675,690899,26553,597576,452357,112710,692797,202712,314244,987620,254591,147792,976900,460442,756151,573257,763898,550031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]