SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 744080 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 744080 [ RunTime:0.006333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522923,685461,393779,971986,662688,1020717,44089,909037,543313,707592,284448,43256,863714,800841,290911,123728,18634,869759,559650,813626,1018086,518427,219797,942489,482933,283775,227806,925112,284203,105592,853070,794815,808692,933357,736864,550398,11079,223580,603429,575163,415754,898597,942069,846247,361264,294045,392868,1004538,794714,233177,368230,121023,491746,753726,495507,257272,699345,1027208,111990,410648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 744080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 744080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]