SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032471 LIMIT 1 [ RunTime:0.002030s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032471 [ RunTime:0.002805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770202,704942,818412,676803,687573,78634,1003131,789978,10561,369660,758634,910368,282540,828057,1008520,422276,607890,1012028,671691,725754,379708,649049,900835,377381,765182,231206,756410,598246,742947,225181,931046,611905,631301,111469,112458,749523,856458,169951,359519,610866,601988,719666,852367,149102,782330,869888,553249,837619,150805,910924,442178,748832,788572,793880,467800,893148,64331,215000,686993,415420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]