SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018770 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018770 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804237,257894,835660,995689,9559,362327,700447,227302,110527,961745,997773,477668,1036109,767213,376474,76517,1018447,159927,759546,624892,129619,828362,165105,712641,359699,590975,696322,164881,649486,384593,907354,624001,787374,513635,200029,41400,103045,267683,867542,795894,534313,656662,330663,343228,480158,750030,874552,184456,338128,86285,79823,1040386,526269,999551,79648,263893,99260,660066,746764,724566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]