SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194424 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194424 [ RunTime:0.003660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530172,889216,650943,951871,298281,1015800,682170,460712,518315,337642,758469,53039,855829,451411,669497,602676,694959,742760,545807,239788,585533,888096,295676,844803,927634,502776,689537,36381,638099,70430,829609,315849,885708,71862,275102,322328,200108,259938,35396,1011042,660372,101990,452670,277717,910478,846536,127597,1035124,171829,693191,204569,470805,904693,323973,804110,79733,350801,724849,380354,241388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002445s ]