SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68766 LIMIT 1 [ RunTime:0.002099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68766 [ RunTime:0.004011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183001,598152,459248,564083,151073,1006614,438483,275281,774170,178790,694872,1037897,374651,225922,31498,856087,415563,477002,1011276,941963,560580,326526,518093,54696,296058,81071,435220,501528,613705,455272,885161,715082,420166,914513,1025132,652768,223706,946000,459862,760944,947223,447961,651576,681154,501644,912127,910174,104772,572526,791310,306999,976375,144348,685538,369551,900061,1014038,669546,914256,626051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001676s ]