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` = 417322 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417322 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15435,429102,982615,243756,974384,415492,729658,822125,144985,145835,504828,610951,133147,68390,649323,956542,975335,819114,253853,647455,260343,367438,937740,584696,917973,1010828,292961,891398,481886,323014,918411,129441,979139,730931,196874,56204,685508,179749,570588,571784,905589,654655,398731,464151,615826,190157,468313,978449,289557,188775,976323,505764,751680,679830,522544,263152,669654,457555,899516,392445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]