SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68633 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68633 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776527,768940,443877,971900,977941,771033,145531,450757,650091,672611,1015168,772128,722744,271245,552144,120267,324964,625071,56008,95264,868863,528957,617549,406538,115607,118193,789574,534989,741503,86986,694773,225526,299750,551432,436223,128945,208723,878549,947032,956364,892732,120553,31468,154711,673201,383328,818980,680615,1031984,667247,368745,825387,300894,698119,897779,555544,756166,643851,388177,833621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]