SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508236 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508236 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104023,73241,435965,754855,847064,819050,638344,646170,4731,981432,472994,945344,283100,194834,630520,598740,206507,403674,194151,458516,613436,265063,380980,913278,783065,616512,861260,860689,643078,549031,948215,500616,779449,410478,14480,130800,218295,395411,79359,562893,288894,970067,740752,299903,861650,591060,142520,897034,717903,506167,799415,464439,124558,494057,1029534,999078,156131,164843,313195,177002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]