SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511683 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511683 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854993,261210,824784,247564,629334,728500,857967,907362,586659,294840,120312,401377,923429,529645,1028201,143079,244957,395487,717467,930341,294159,408014,698355,293791,298563,1042318,533026,295860,661710,469210,693688,493395,841094,147454,170436,951332,78423,902577,96780,131898,725782,877762,353647,269449,274627,496143,311878,864008,192382,1029233,57945,798724,660421,802398,965602,433160,205750,153779,118542,477292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]