SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537595 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537595 [ RunTime:0.003709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72798,793950,427153,792369,880861,622694,806957,924025,552142,789471,927815,957086,924343,711163,956148,65709,598499,595748,761898,578246,896651,280626,640388,837317,368605,206117,787736,107771,508949,84748,940265,751440,383851,832382,96140,959580,510079,436655,721533,88459,144268,118592,742895,335943,661397,920595,71828,287119,599183,914373,879403,496516,335887,546728,46135,398083,584184,753516,862880,803105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]