SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516097 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516097 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608000,724066,345083,1004388,515462,694410,682572,924239,336489,762100,518026,350989,750786,525089,434048,85335,317275,308459,841410,650110,554229,74511,426421,473712,453528,443673,840577,934007,489643,512179,861010,824928,746735,238383,87999,825742,932569,1017372,566625,403954,317702,855550,223000,993218,598781,347818,281207,699063,150797,559195,370280,1013278,539513,153464,518299,234048,909137,232756,856638,1047665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]