SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349219 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349219 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176342,454613,858967,984391,920481,1011413,243596,107513,101947,413852,867387,449554,279909,1047603,115590,919259,301946,650583,621511,361783,30778,523733,1033645,1002355,1025944,720642,344355,859080,132675,306136,90891,131996,49925,651906,572185,667071,102762,290379,415882,375499,225562,1022179,284646,435703,1025993,348284,88441,958878,985980,668585,749583,470476,185232,80366,601049,1035494,745933,294940,352225,964987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]