SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019039 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019039 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694263,697612,904274,413208,633023,228350,394775,342807,410689,516981,611564,765608,888500,921966,358276,232832,275365,717473,191111,382811,224628,242399,47461,609556,624148,422834,1043832,78948,889571,828298,1035526,390205,341959,165270,986341,989858,1006623,795887,406747,870600,436548,757673,753793,1042129,812284,842001,634258,426204,965681,869527,271073,209560,1002881,118017,963157,919699,67293,347919,1040406,410537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001075s ]