SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802543 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802543 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218774,442897,535779,376193,745328,389810,13715,439563,781471,593472,95373,397951,824519,159372,656148,685669,539311,725060,577349,331432,299060,86967,183638,89684,1012727,734853,387503,904471,1023148,215491,571533,621372,266803,722862,115367,902185,986407,404242,919847,536253,361403,909731,962202,732844,936007,972275,612136,296749,661,251269,237985,762670,1039740,536442,677441,643003,610864,555246,283069,747748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]