SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415805 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415805 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874835,305522,651258,748961,1032400,293375,236727,851985,91766,330922,1031060,491202,4655,537273,27991,302504,521371,518133,283241,715864,435503,820030,365425,179320,996127,528345,603853,501052,668239,1041962,827030,425025,593620,969295,750516,871884,288354,929458,40649,847093,284688,963930,745511,1036585,652266,164521,709419,198552,762908,471617,693957,257191,148320,129850,75580,58943,593031,627644,416436,496498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]