SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781951 LIMIT 1 [ RunTime:0.001621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781951 [ RunTime:0.002800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258301,144894,329341,104209,351504,817801,920327,969845,49178,811616,302264,1000942,270655,792032,129692,459250,178327,123144,368409,39090,336867,922431,247180,1043082,665535,408524,884714,884043,655379,213244,193953,873926,467080,981834,796839,1034371,1016810,243936,252135,598303,203326,769411,747654,94633,191578,693115,438274,1046457,260959,737926,87350,814480,998712,1003043,301054,273912,1041982,537301,115531,731984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]