SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800266 LIMIT 1 [ RunTime:0.001490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800266 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813699,335204,584850,918182,116407,117514,617773,363797,476274,412473,499595,183158,328500,609873,590665,366131,718615,1030789,102839,991639,622991,988918,558509,164304,829326,1039663,638640,125076,748449,581193,519330,410317,114476,873997,337598,1041568,719023,858770,33307,411808,359205,238254,589636,1029994,85880,829280,491020,460164,443312,888153,121566,272155,948699,368764,467975,814536,583359,739229,618047,65478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]