SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415147 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415147 [ RunTime:0.003318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652086,381995,881743,172234,551805,881752,385786,740408,615858,214584,578952,328997,1040280,815487,516048,874108,939376,989321,999214,324625,274461,384634,238881,687878,891813,568508,848881,841366,494271,217132,560113,874513,336630,583093,447293,107120,536277,269556,958943,654916,395176,246941,430499,372373,917727,587872,929483,488903,63321,656433,527285,143722,334836,299057,79761,274624,159928,23361,842183,937760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]