SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518322 LIMIT 1 [ RunTime:0.000951s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518322 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470668,361527,331026,209928,846421,72344,463675,249243,53244,1036698,886199,791669,728516,410438,862394,105382,238324,478134,230212,713325,186521,12927,222597,580157,134388,243359,518295,739011,707015,56029,464534,293609,139834,271398,570006,317837,218077,645221,1237,195523,230013,9913,128978,720175,308861,715170,646212,167358,551440,128389,381820,39515,980935,572861,1032666,301079,341472,524914,886473,766701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001615s ]