SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036105 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036105 [ RunTime:0.005328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932540,536800,136804,214467,928618,231242,143158,20294,844784,963881,576950,79995,24934,550206,805466,115960,994082,373460,61006,251543,936446,45053,1046900,32588,835662,948464,1019294,85503,166933,571074,87386,751121,613932,428033,877379,980975,82771,599800,933684,49918,135532,441274,435424,472810,172486,366800,113575,57288,502146,984331,198613,829967,805001,596011,585294,818696,1017817,177616,254611,779249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]