SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002606s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415260 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415260 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745708,91991,515277,661153,466120,982367,470009,944382,958639,516467,321618,208954,428992,53176,39716,624258,602039,30640,212618,860134,1007713,1038600,236710,938577,297847,373031,297264,712565,878636,381154,907014,98045,199182,901278,893881,751865,330157,227289,357595,936217,244861,18399,494718,750288,35819,907293,139310,191247,271747,398104,489800,1005773,621234,690880,271757,581026,554642,548729,68738,870357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]