SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68383 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68383 [ RunTime:0.002402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775628,1013911,153932,776558,188639,384108,807354,766552,219181,568220,635065,92008,911882,277532,595954,254058,803441,398958,969239,837310,233025,231059,496562,430371,1042893,796080,587585,230009,659350,157278,929609,577049,83693,927911,603877,623324,713649,972171,260851,344811,569204,361132,214562,960939,611882,638131,896595,622123,677433,978679,344009,479168,563604,349220,145086,598361,687440,63055,664590,334701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]