SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004626 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004626 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325147,50767,236192,404023,115469,131531,452366,734665,28487,954899,34855,1007274,632926,769620,94919,94502,821047,773664,80980,224798,668142,855080,244592,115168,713425,648410,723852,513541,744474,211098,480239,47840,705920,1016974,624660,390011,841601,61157,383249,310565,544914,596902,353247,116001,354057,463179,874216,865063,603406,943067,970694,430665,507664,291618,385796,69200,385698,416961,511847,206059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]