SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420063 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420063 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696593,249545,1003920,792767,109071,628685,998098,421019,269204,379817,671777,794862,402572,431787,836154,883587,371830,452808,433027,49347,523078,264122,871451,1031542,600101,620474,520471,706592,61057,347977,907887,948720,1039340,257627,14427,697592,553072,998564,890110,535629,416340,499151,264107,107807,580363,853683,744335,469113,52243,145128,999396,297611,426336,285334,421231,464982,308267,810088,327663,344402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]