SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200641 LIMIT 1 [ RunTime:0.002079s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200641 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873027,518359,491528,495158,138102,923406,766270,506031,796375,476021,939304,115439,703277,399842,173723,847046,298201,764252,596856,168423,687032,328792,1018782,851914,297691,498355,470422,884064,402840,253491,148060,539399,1046643,488758,488998,607809,1034381,388549,877190,507876,1007717,681098,501518,950848,173158,592248,814711,1009135,132766,801088,470821,287119,1005670,1042607,268213,24127,673578,299380,232744,216489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]