SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022038 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022038 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669704,939552,694880,1024663,218519,593107,79996,629070,630423,653551,473494,506006,1015276,520224,148715,689908,597753,382932,538325,378712,534513,691529,736934,952501,777392,412120,753691,765469,447185,90571,446507,259913,81184,772101,243863,799444,1036921,24937,215285,874684,822954,905687,740844,295396,644308,687148,951978,335159,161677,701792,685768,735934,1007616,343126,850449,990167,682728,812360,378061,109613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000895s ]