SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512227 LIMIT 1 [ RunTime:0.002960s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512227 [ RunTime:0.003496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704226,399421,260508,141523,885429,953087,993938,42263,130014,249144,540298,207231,1000412,195215,812155,235817,335360,349069,170294,555416,173098,833316,252757,965367,677868,367729,285365,68194,167780,815585,466516,886236,630059,227321,649560,676716,822179,274777,801233,34017,603559,234709,894098,51347,652689,260187,703775,2002,248384,244302,717363,880974,974210,1028867,371455,686990,422650,424400,691449,16016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004778s ]