SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437253 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437253 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707239,612343,1043836,918691,583227,641026,372117,1030625,471193,894465,412623,854859,764794,1043116,652137,951022,808559,493181,982829,12891,211511,619819,750074,32522,113953,502845,701463,1019173,473572,1020615,160479,242313,602644,109171,394784,630036,924039,424545,144415,434042,130988,979690,578170,441284,893548,248004,231561,356598,933744,553353,51533,792575,532046,560642,271374,509091,19256,576526,754145,751186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]