SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044271 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044271 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101517,28591,194351,114545,106114,223074,375741,703901,311143,702144,616673,83208,915430,611985,828486,925810,437143,147093,250245,479530,695605,938103,873680,191335,966160,788485,67780,635361,954228,646685,446996,348752,722201,893765,352605,631460,997882,707051,459541,1047442,470473,582175,987792,629656,787484,889931,322180,568137,912061,409159,1016777,950812,754921,237265,91781,249228,466520,243039,899743,359707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]