SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416111 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416111 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657808,481426,634614,687635,614970,317251,360112,761997,331995,872355,412351,110079,282177,391340,420640,1010047,800339,774519,852538,200428,238687,890479,216622,374404,88880,917496,227070,51105,168115,523245,283095,132402,913355,645717,490083,98100,270127,653381,119969,927216,184874,81383,1040964,406188,972553,21745,835837,178927,996701,176125,552118,363470,801334,10153,935600,389016,869477,267523,383117,13472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001336s ]