SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378951 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378951 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017121,382313,711228,122705,418920,885666,157613,246055,1048206,630133,446191,486846,190259,244152,217685,277423,235143,217117,396349,264241,829131,546566,463573,105501,938068,287744,136713,584568,977613,502648,55186,757860,156097,526546,257509,931555,851228,610615,765465,923172,404655,187899,620376,154363,1012537,782062,491915,1035708,197211,220697,445804,989210,47942,733112,988130,48535,975148,544199,992612,177430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]