SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 209140 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 209140 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103684,555834,426147,26101,983445,1003890,634139,628680,764198,783588,666039,90991,185082,347836,996079,128549,593484,446817,709960,2440,366454,676799,155641,585457,266931,352275,673832,284442,194189,907129,633490,322101,749918,685563,37939,160279,513803,993265,889539,488284,485510,21395,750988,807121,422556,633186,744826,462427,941802,852624,455354,76609,388003,408125,848960,340839,814309,165445,502649,9364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 209140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 209140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]