SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452002 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452002 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852722,195970,637906,836234,309964,427224,401258,136726,319494,628775,224866,337937,585953,1005662,803139,65956,401915,314877,244750,358532,61229,527833,1025219,759033,298849,203760,228513,924672,569631,609465,822476,943493,505621,928670,184116,823258,706384,530279,47913,921970,773887,75166,569857,449541,1011961,408353,161377,439072,116035,228732,225929,585350,1031377,400836,784666,941763,1048784,347047,217031,922063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]