SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555346 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555346 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755390,586299,324634,567054,924083,974466,133059,864848,346870,118809,627518,582141,162182,295203,1036688,31203,722494,995293,111937,650889,271943,140236,219183,108638,376279,107309,581545,544635,207456,33343,354079,383992,668015,848337,518773,230219,672801,601476,984077,735759,98318,500614,284192,89889,491337,586033,153497,737216,423805,914613,967261,920671,231791,426068,448800,242117,92705,500951,630253,145572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]