SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 208601 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 208601 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73991,337088,424009,539928,137880,357197,210377,842598,558533,329441,956474,868019,748844,210631,619055,943638,259844,548737,158181,684702,88962,883895,85034,150811,59095,964655,356397,1005129,457076,691513,870720,132423,163435,564443,518425,880657,416023,576849,143646,842473,838480,559740,787538,246741,392158,410277,545377,229384,644206,803194,148903,747727,843845,959835,14277,415624,602137,559266,392257,338938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 208601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 208601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]