SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 745254 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 745254 [ RunTime:0.002784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488405,260307,332079,563753,504418,851827,155786,634224,945804,944016,481298,971950,293703,418680,974919,359305,257754,1037702,986008,625945,53058,526504,20097,86492,437871,301536,736503,943582,67730,9771,953315,497168,566107,376841,236272,247349,801940,34265,216109,790361,688214,1045745,488268,778706,43100,814020,447299,929466,664020,470504,241755,397702,557710,337107,648962,999964,226983,1013837,412151,921657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 745254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 745254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]