SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006192 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006192 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189281,1003823,63509,994886,930023,967561,1029970,523306,345978,804220,129470,490236,994193,95219,399054,938681,167218,874230,705756,734302,2051,1022732,168856,539334,765762,806629,340345,384114,615326,828956,437786,1043795,747998,94356,738629,222166,889102,132970,224381,380130,893336,161369,732987,905056,848583,304985,457789,309034,713316,506695,863204,691431,620962,110449,869063,306647,961526,895518,849605,548843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]