SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517599 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517599 [ RunTime:0.003916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565298,892492,532653,471262,97609,277705,963525,78240,23014,72240,933772,229949,180412,187113,23833,947598,720639,422055,351990,726509,177867,1005859,841061,1015120,669925,124998,579088,918313,504635,836587,567123,576233,563440,85303,565947,121525,988945,641711,258944,9650,93705,644643,209311,295781,894223,584774,108704,594518,366625,374503,129845,451946,59020,797697,886778,172561,243677,310994,1024585,837694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]