SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006056 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006056 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258245,849051,1011129,1035916,469417,680400,388780,994678,290258,848855,99898,834558,601693,555716,483439,380277,231694,53886,5474,218482,297430,380694,563727,370118,109059,939764,354908,562995,549725,398038,301437,873513,317595,149682,838692,516122,339377,154192,453093,457954,866838,1043863,102284,328793,61248,568336,191705,140023,371284,967610,484369,865068,370948,126772,354101,355793,1009207,949298,743169,488012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]